select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseArea >= 100 and a.houseArea <= 200) and (b.cnpropertyname like '%Old House in TaiAn Road%' or b.enpropertyname like '%Old House in TaiAn Road%') order by updateTime Desc, a.dftpic desc
Three floors of the whole building, independent space, courtyard, terrace, as well as climbing the back wall and the entire fence of the mountain tiger, green. ...
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...